package cn.wjzhang.core.config;

import com.p6spy.engine.spy.appender.MessageFormattingStrategy;
import org.apache.commons.lang3.StringUtils;

/**
 * 自定义 p6spy sql输出格式
 *
 * @author
 */
public class P6spySqlFormatConfigure implements MessageFormattingStrategy {


    @Override
    public String formatMessage(int connectionId, String now, long elapsed, String category, String prepared, String sql, String url) {
        return StringUtils.isNotBlank(sql) ?  " 耗时 " + elapsed + " ms | SQL 语句： \n"  + sql.replaceAll("[\\s]+", " ") +
                ";" : "";
    }


}
